﻿Public Class clsStorageLocationMst
    Public Function getAvailableList(code As String, location_no_Ax As String, location_no_Ay As String) As DataTable
        Dim szSql As String = String.Empty
        szSql &= "SELECT * FROM sf.t_mst_storage_location WHERE 1 = 1 and status = ? and validity = ? and code = ? "
        szSql &= " and (location_no like '" & location_no_Ax & "%' or location_no like '" & location_no_Ay & "%')"
        szSql &= " order by sort,location_no desc"
        Dim dt As DataTable = DBacs.ExecuteSql(szSql, -1, "0", "1", code)
        Return dt
    End Function
End Class
